package com.augurit.smartform.database;

/**
 * 数据库字段信息类
 * @author cuigeqiang
 *
 */
public class Column {
	private String fieldId;
	private String name;
	private String cnName;
	private Integer length;
	private Integer precision;
	private Integer scale;
	private boolean notNull;
	private boolean unique;
	private boolean index;
	private boolean primaryKey;
	private boolean foreignKey;
	private boolean checked;
	private String dictionary;
	private String dbType;
	private String sqlDefaultValue;
	private String defaultValue;
	private String sqlType;
	private String tag;									//去掉NAME相同的RIDIO字段
	private String refTable;
	private String refColumn;
	private String table;								//含有版本信息的表名
	private String objectName;							//不含版本信息的表名
	private String value;
	private String checkedValue;						//单选框、复选框的值，用于添加到默认值中
	private String sqlValue;
	private String sqlQueryValue;
	private Long tableId;								//关联表结构id(保存数据库时使用)
	private String columnType;							//工作流使用的数据库类型
	private String propertyName;						//工作流使用的属性名
	private boolean summary;							//是否汇总字段（工作流使用）
	public String getPropertyName() {
		return propertyName;
	}
	public void setPropertyName(String propertyName) {
		this.propertyName = propertyName;
	}
	public String getSqlQueryValue() {
		return sqlQueryValue;
	}
	public void setSqlQueryValue(String sqlQueryValue) {
		this.sqlQueryValue = sqlQueryValue;
	}
	public String getSqlValue() {
		return sqlValue;
	}
	public void setSqlValue(String sqlValue) {
		this.sqlValue = sqlValue;
	}
	public String getValue() {
		return value;
	}
	public void setValue(String value) {
		this.value = value;
	}
	public String getTable() {
		return table;
	}
	public void setTable(String table) {
		this.table = table;
	}
	public String getName() {
		return name.toUpperCase();
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getCnName() {
		return cnName;
	}
	public void setCnName(String cnName) {
		this.cnName = cnName;
	}
	public Integer getLength() {
		return length;
	}
	public void setLength(int length) {
		this.length = length;
	}
	public Integer getPrecision() {
		return precision;
	}
	public void setPrecision(int precision) {
		this.precision = precision;
	}
	public Integer getScale() {
		return scale;
	}
	public void setScale(int scale) {
		this.scale = scale;
	}
	public boolean isNotNull() {
		return notNull;
	}
	public void setNotNull(boolean notNull) {
		this.notNull = notNull;
	}
	public boolean isUnique() {
		return unique;
	}
	public boolean isIndex() {
		return index;
	}
	public String getDbType() {
		return dbType;
	}
	public void setDbType(String dbType) {
		this.dbType = dbType;
	}
	public String getDefaultValue() {
		return defaultValue;
	}
	public void setDefaultValue(String defaultValue) {
		this.defaultValue = defaultValue;
	}
	public String getSqlType() {
		return sqlType;
	}
	public void setSqlType(String sqlType) {
		this.sqlType = sqlType;
	}
	public String getRefTable() {
		return refTable;
	}
	public void setRefTable(String refTable) {
		this.refTable = refTable;
	}
	public String getRefColumn() {
		return refColumn;
	}
	public void setRefColumn(String refColumn) {
		this.refColumn = refColumn;
	}
	public String getFieldId() {
		return fieldId;
	}
	public void setFieldId(String fieldId) {
		this.fieldId = fieldId;
	}
	public void setUnique(boolean unique) {
		this.unique = unique;
	}
	public void setIndex(boolean index) {
		this.index = index;
	}
	public String getDictionary() {
		return dictionary;
	}
	public void setDictionary(String dictionary) {
		this.dictionary = dictionary;
	}
	public boolean isPrimaryKey() {
		return primaryKey;
	}
	public void setPrimaryKey(boolean primaryKey) {
		this.primaryKey = primaryKey;
	}
	public boolean isForeignKey() {
		return foreignKey;
	}
	public void setForeignKey(boolean foreignKey) {
		this.foreignKey = foreignKey;
	}
	public String getSqlDefaultValue() {
		return sqlDefaultValue;
	}
	public void setSqlDefaultValue(String sqlDefaultValue) {
		this.sqlDefaultValue = sqlDefaultValue;
	}
	public String getObjectName() {
		return objectName;
	}
	public void setObjectName(String objectName) {
		this.objectName = objectName;
	}
	public String getTag() {
		return tag;
	}
	public void setTag(String tag) {
		this.tag = tag;
	}
	public Long getTableId() {
		return tableId;
	}
	public void setTableId(Long tableId) {
		this.tableId = tableId;
	}
	public boolean isChecked() {
		return checked;
	}
	public void setChecked(boolean checked) {
		this.checked = checked;
	}
	public String getCheckedValue() {
		return checkedValue;
	}
	public void setCheckedValue(String checkedValue) {
		this.checkedValue = checkedValue;
	}
	public String getColumnType() {
		return columnType;
	}
	public void setColumnType(String columnType) {
		this.columnType = columnType;
	}
	public boolean isSummary() {
		return summary;
	}
	public void setSummary(boolean summary) {
		this.summary = summary;
	}
}
